package com.zygh.policeasset.mapper;

import com.zygh.policeasset.pojo.DailyMaintenanceBigClassification;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface DailyMaintenanceBigClassificationMapper {

    @Select({"<script>" +
            "select * from daily_maintenance_big_classification   " +
            "<where>" +
            "<if test='name != null and name.length &gt; 0'> name like concat('%',#{name},'%')</if>" +
            "<if test='type != null and type.length &gt; 0'> and type = #{type}</if>" +
            "</where>" +
            "</script>"
    })
    List<DailyMaintenanceBigClassification> findAll(@Param("name") String name,
                                                    @Param("type") String type);

}